Reports Registry entry
Several Registry entries are required to generate a report:
Specify an association between an internal report type (e.g. Crystal, Excel) and the action to perform when the report is run in the client.
Description
EMu provides several output formats as part of its standard reporting environment. Each report type has a report name that identifies it in the System (e.g. Crystal, Excel), and an output format that defines what the reporting system has to do to run the report.
Usage
This Registry entry is assigned at the system level only:
Key | System |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Action
|
Key 5 | report |
Value | format |
System
|
Setting
|
Reports
|
Action
|
report | format |
where:
report |
is the name of a type of report, e.g. |
|||||||||||||||||||
format |
is in the format: [action][location][options] where: |
|||||||||||||||||||
|
This entry specifies an action for running a Crystal report:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Action
|
Key 5 | Crystal
|
Value | Run ODBC Crystal/crystal.exe %r
|
In this example, when a Crystal report is run, the output is stored in the ODBC Data Source for the current module. If the user invokes a Crystal report from the Parties module, the output file is stored under the ODBC Data Source that exists on their machine for the eparties module. The Crystal executable is invoked on the client machine and passed the file name of the report to run.
The following entry specifies an action for running an Excel report:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Action
|
Key 5 | Excel
|
Value | Launch ODBC %r
|
In this example, when an Excel report is run, the output is stored in the ODBC Data Source for the current module. If the user invokes an Excel report from the Parties module, the output file is stored under the ODBC Data Source that exists on their server for the eparties module. The output file has a file extension of .xls, as defined by the Reports|Extension Registry entry. The output file name is substituted for the %r
, and Excel is launched as it would be if the user double-clicked an .xls file in Windows Explorer.
Specify an association between a report type and its file extension.
Description
EMu provides several output formats as part of its standard reporting environment. Each report type has a report name that identifies it in the System and a suffix that is the file extension to be appended to the output file's name when generated by the System. The suffix will generally be the file extension associated with the destination report viewing program (e.g. .xls
for an Excel or Microsoft ADO report).
Usage
This Registry entry is assigned at the system level only:
Key | System |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Extension
|
Key 5 | report |
Value | suffix |
System
|
Setting
|
Reports
|
Extension
|
report | suffix |
where:
report |
is the name of a type of report, e.g.:
|
suffix |
is the file extension associated with the report type, e.g. .xls for an Excel report or Microsoft ADO report; |
This entry specifies that when creating reports of type Word, the output file name should have .doc
appended to it:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Extension
|
Key 5 | Word
|
Value | .doc
|
This entry specifies that when creating reports of type Crystal, the output file name should have .rpt
appended to it:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Extension
|
Key 5 | Crystal
|
Value | .rpt
|
This entry specifies that when creating reports of type Microsoft ADO, the output file name should have .xls
appended to it:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Extension
|
Key 5 | Microsoft ADO
|
Value | .xls
|
Note: When building a new Microsoft ADO report in EMu and running it for the first time, in this case Microsoft Excel will open by default. If you specified .doc
as the Value, Microsoft Word would open by default.
Specify a filter to be run before sending report output to the client.
Description
The standard EMu reporting facility outputs reporting data in XML format. A filter residing on the server can translate the XML into another format if required. The purpose of this entry is to define a filter to be applied to the XML before it is sent to the client. Every report type can have a filter associated with it. The filter must reside on the server in ~/utils/filtername
.
This entry is optional. Most report types are saved on the client machine under the ODBC Data Source for the current module and are translated to ODBC.
The filter is run on the server after any Media Filter.
Usage
This Registry entry is assigned at the system level only:
Key | System |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Filter
|
Key 5 | report |
Value | filter |
System
|
Setting
|
Reports
|
Filter
|
report | filter |
where:
report |
is the name of a type of report, e.g. |
filter |
is the name of a filter to be applied to the XML before it is sent to the client. The filter must reside on the server in |
This entry specifies a filter texxmlodbc
that translates Crystal reports into ODBC before being sent to the client:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Filter
|
Key 5 | Crystal
|
Value | texxmlodbc
|
Specify a filter that translates an image's path from its server path to its client-side path.
Description
When a report is run, any images that are displayed in the report have their path stored in the Multimedia field. However, this path is to the image stored on the server. The purpose of this entry is to define a filter that translates the path to what it will be on the client machine, enabling the reporting program to find and display the image.
Usage
This Registry entry is assigned at the system level only:
Key | System |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Media Filter
|
Key 5 | report or Default |
Value | filter |
System
|
Setting
|
Reports
|
Media Filter
|
report or Default |
filter |
where:
report |
is the name of a type of report, e.g. Crystal, Excel; or use |
filter |
is the name of the filter that is run on the server, located in |
This entry specifies a filter called reportsmedia
for all Crystal reports:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Media Filter
|
Key 5 | Crystal
|
Value | reportsmedia
|
This entry specifies that all report types without their own Media Filter entry will be filtered by reportsmedia
:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Media Filter
|
Key 5 | Default
|
Value | reportsmedia
|
Specify an association between a report type (e.g. Crystal) and the name to display in the client.
Description
EMu provides several output formats as part of its standard reporting environment. Each report type has a report name that identifies it in the System (e.g. Word
) and a display name shown in the client (e.g. MS Word). A list of existing report types can be viewed in the Report Properties window (select Reports on the Home tab of the Ribbon, right-click a report, select Properties and click the Type drop list). A Reports Name entry exists for every report type.
Usage
This Registry entry is assigned at the system level only:
Key | System |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Name
|
Key 5 | report |
Value | display |
System
|
Setting
|
Reports
|
Name
|
report | display |
where:
report |
is the name of a type of report, e.g. |
display |
is the display name shown in the client (e.g. |
This entry specifies a report type of Word with the displayable name of Microsoft Word
:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Name
|
Key 5 | Word
|
Value | Microsoft Word
|
Associates a report type (e.g. Crystal Report) with an export format (e.g. ODBC data set, ADO record set).
Description
EMu's Reporting subsystem was modified with version 5.0 in order to bypass some filtering which occurs when a Crystal Report or Microsoft report (Excel, Word, etc.) is generated out of EMu. Bypassing the filtering improves report generation and performance.
The Reporting subsystem has been modified in two major ways:
- Crystal Reports.
In order to build and generate a report, Crystal Reports requires a .csv file with the exported EMu data. In previous versions of EMu, data was exported as XML and then filtered to produce one or more ODBC compliant .csv files. The filtering process has been bypassed and EMu is now able to generate the ODBC data source directly.
Note: This change does not affect the way that you build a Crystal Report, it simply means that the ODBC data source (one or more .csv files) output by EMu is generated far more efficiently. With the Reports|Type Registry entry it is possible to specify whether the filtering process is bypassed or not.
- Two new report formats have been introduced that report directly to an ActiveX Data Objects (ADO) RecordSet object (XML) rather than reporting to an ODBC data source (CSV). The new report options are:
- Crystal ADO: report using ADO RecordSets for Crystal (which are accessible via Crystal's ADO connector).
- Microsoft ADO: report using ADO RecordSets for Microsoft products.
Usage
This Registry entry is assigned at the system level only:
Key | System |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Type
|
Key 5 | report |
Value | value |
System
|
Setting
|
Reports
|
Type
|
report | value |
where:
report |
is the name we have used for a type of report, e.g. Tip: The name is specified in a Reports|Name Registry entry. |
|||||||
value |
is: |
|||||||
|
This entry specifies that the report type we've called Crystal CSV
generates data by bypassing the filtering process and generating the ODBC data source directly:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Type
|
Key 5 | Crystal CSV
|
Value | 1
|
This entry specifies that the report type we've called Crystal ADO
generates data in the Crystal ADO recordset:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Reports
|
Key 4 | Type
|
Key 5 | Crystal ADO
|
Value | 2
|